﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Migrations;
using CollegeReviewApp.DataModels;

namespace CollegeReviewApp.Data
{
    public class Seeder
    {
        public static void Seed(ApplicationDbContext db)
        {
            db.Colleges.AddOrUpdate(
                x => x.Name,
                new College { Name = "Princeton University", Phone = "(609) 258-3000", URL = "http://www.princeton.edu/main/", Address = "Princeton, New Jersey 08544", Description = "Princeton University is a private institution that was founded in 1746. It has a total undergraduate enrollment of 5,336, its setting is suburban, and the campus size is 600 acres. It utilizes a semester-based academic calendar. Princeton University's ranking in the 2014 edition of Best Colleges is National Universities, 1. Its tuition and fees are $40,170 (2013-14). Princeton, the fourth-oldest college in the United States, is located in the quiet town of Princeton, New Jersey. Within the walls of its historic ivy-covered campus, Princeton offers a number of events, activities and organizations. The Princeton Tigers, members of the Ivy League, are well known for their consistently strong men's and women's lacrosse teams. Students live in one of six residential colleges that provide a residential community as well as dining services but have the option to join one of more than 10 eating clubs for their junior and senior years. The eating clubs serve as social and dining organizations for the students who join them. Princeton's unofficial motto, \"In the Nation's Service and in the Service of All Nations,\" speaks to the university's commitment to community service.", Tuition = 40170, AcceptanceRate = 7.8, Enrollment = 5336, Image = "http://colleges.usnews.rankingsandreviews.com/img/college-photo_6978..jpg"},
                new College { Name = "Harvard University", Phone = "(617) 495-1000", URL = "https://college.harvard.edu/", Address = "86 Brattle Street Cambridge, MA 02138", Description = "Harvard University is a private institution that was founded in 1636. It has a total undergraduate enrollment of 6,658, its setting is urban, and the campus size is 5,076 acres. It utilizes a semester-based academic calendar. Harvard University's ranking in the 2014 edition of Best Colleges is National Universities, 2. Its tuition and fees are $42,292 (2013-14). Harvard is located in Cambridge, Massachusetts, just outside of Boston. Harvard's extensive library system houses the oldest collection in the United States and the largest private collection in the world. There is more to the school than endless stacks, though: Harvard's athletic teams compete in the Ivy League, and every football season ends with \"The Game,\" an annual matchup between storied rivals Harvard and Yale. At Harvard, on-campus residential housing is an integral part of student life. Freshmen live around the Harvard Yard at the center of campus, after which they are placed in one of 12 undergraduate houses for their remaining three years. Although they are no longer recognized by the university as official student groups, the eight all-male \"final clubs\" serve as social organizations for some undergraduate students; Harvard also has five female clubs.", Tuition = 42292, AcceptanceRate = 6.0, Enrollment = 6658, Image = "http://colleges.usnews.rankingsandreviews.com/img/college-photo_20473..jpg" },
                new College { Name = "Yale University", Phone = "(203) 432-4771", URL = "http://www.yale.edu/", Address = "Yale University New Haven, CT 06520", Description = "Yale University is a private institution that was founded in 1701. It has a total undergraduate enrollment of 5,405, its setting is urban, and the campus size is 342 acres. It utilizes a semester-based academic calendar. Yale University's ranking in the 2014 edition of Best Colleges is National Universities, 3. Its tuition and fees are $44,000 (2013-14). Yale University, located in New Haven, Connecticut, is known for its excellent drama and music programs, which reach outside the classroom with student organizations such as the Yale Whiffenpoofs, a famous a cappella group, and the Yale Dramatic Association. The Yale Bulldogs compete in the Ivy League and are well known for their rivalry with Harvard. Students are assigned to live in one of 12 residential colleges during their time at Yale. Each college has a master and dean who live in the college and eat with students in the dining halls. Cultural houses provide a space for students to build a sense of cultural identity on campus.", Tuition = 44000, AcceptanceRate = 7.0, Enrollment = 5405, Image = "http://colleges.usnews.rankingsandreviews.com/img/college-photo_8737._445x280-zmm.jpg" },
                new College { Name = "Columbia University", Phone = "(212) 854-1754", URL = "http://www.columbia.edu/", Address = "2960 Broadway New York, NY 10027", Description = "Columbia University is a private institution that was founded in 1754. It has a total undergraduate enrollment of 6,068, its setting is urban, and the campus size is 36 acres. It utilizes a semester-based academic calendar. Columbia University's ranking in the 2014 edition of Best Colleges is National Universities, 4. Its tuition and fees are $49,138 (2013-14). Columbia University, located in Manhattan’s Morningside Heights neighborhood in New York City, offers a wide range of student activities. The Columbia Lions field more than 25 NCAA Division I teams in the Ivy League. More than 90 percent of students live in on-campus housing, ranging from traditional residence halls to university-owned brownstones. Many of the brownstones are populated by the more than 25 Greek fraternity and sorority chapters on campus, whose membership includes about 10 percent of the student body. Organizations such as Urban New York, which gives out free tickets to city events, foster student interaction with life in the Big Apple.", Tuition = 49138, AcceptanceRate = 7.4, Enrollment = 6068, Image = "http://colleges.usnews.rankingsandreviews.com/img/college-photo_19002..jpg" },
                new College { Name = "Stanford University", Phone = "(650) 723-2300", URL = "http://www.stanford.edu/", Address = "450 Serra Mall Stanford, CA 94305", Description = "Stanford University is a private institution that was founded in 1885. It has a total undergraduate enrollment of 7,063, its setting is suburban, and the campus size is 8,180 acres. It utilizes a quarter-based academic calendar. Stanford University's ranking in the 2014 edition of Best Colleges is National Universities, 5. Its tuition and fees are $43,245 (2013-14). Stanford University’s pristine campus is located in California’s Bay Area, about 30 miles from San Francisco. Stanford offers a wide range of student organizations, including the Stanford Pre-Business Association and Stanford Solar Car Project, which designs, builds and races a solar car every two years. The Stanford Cardinals are well known for the traditional \"Big Game\" against Cal, an annual football competition that awards the Stanford Axe—a sought-after trophy—to the victor. Stanford also has successful programs in tennis and golf. Only freshman are required to live on campus, but students are guaranteed housing for all four years and most choose to remain on campus. Greek life at Stanford represents approximately 10 percent of the student body.", Tuition = 43245, AcceptanceRate = 6.6, Enrollment = 7063, Image = "http://colleges.usnews.rankingsandreviews.com/img/college-photo_199..jpg" }
                );
            db.Reviews.AddOrUpdate(
                x=>x.Comment,
                new Review{Name="Josh", Comment="Test Review for c1", CollegeId=1},
                new Review{Name="Josh", Comment="Test Review for c2", CollegeId=2},
                new Review{Name="Josh", Comment="Test Review for c3", CollegeId=3},
                new Review{Name="Josh", Comment="Test Review for c4", CollegeId=4},
                new Review{Name="Josh", Comment="Test Review for c5", CollegeId=5},
                new Review{Name="Josh", Comment="Test Review  again for c1", CollegeId=1},
                new Review{Name="Josh", Comment="Test Review again for c4", CollegeId=4}

                );
        }
    }
}
